IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'CompanyGetByID')
	BEGIN
		DROP  Procedure  CompanyGetByID
	END

GO

CREATE Procedure CompanyGetByID
(
	@CompanyID int
)
AS

SELECT CompanyID
	, CompanyName
	, URL
	, Symbol
	, Exchange
FROM Companies
WHERE CompanyID = @CompanyID

